/*
 * Copyright (c) 2008, Spagettikod | Stockholm
 * All rights reserved.
 *
 * Redistribution and use in source and binary forms, with or without
 * modification, are permitted provided that the following conditions are met:
 *
 *   * Redistributions of source code must retain the above copyright notice,
 *     this list of conditions and the following disclaimer.
 *   * Redistributions in binary form must reproduce the above copyright
 *     notice, this list of conditions and the following disclaimer in the
 *     documentation and/or other materials provided with the distribution.
 *   * Neither the name of the Spagettikod | Stockholm nor the names of its
 *     contributors may be used to endorse or promote products derived from
 *     this software without specific prior written permission.
 *
 * THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS "AS IS"
 * AND ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE
 * IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE
 * ARE DISCLAIMED. IN NO EVENT SHALL THE COPYRIGHT OWNER OR CONTRIBUTORS BE
 * LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL, SPECIAL, EXEMPLARY, OR
 * CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT LIMITED TO, PROCUREMENT OF
 * SUBSTITUTE GOODS OR SERVICES; LOSS OF USE, DATA, OR PROFITS; OR BUSINESS
 * INTERRUPTION) HOWEVER CAUSED AND ON ANY THEORY OF LIABILITY, WHETHER IN
 * CONTRACT, STRICT LIABILITY, OR TORT (INCLUDING NEGLIGENCE OR OTHERWISE)
 * ARISING IN ANY WAY OUT OF THE USE OF THIS SOFTWARE, EVEN IF ADVISED OF THE
 * POSSIBILITY OF SUCH DAMAGE.
 */

package com.spagettikod.t437.simpledb;

import java.util.Hashtable;
import java.util.LinkedList;
import java.util.List;
import java.util.Map;

import javax.swing.table.AbstractTableModel;

import org.apache.commons.logging.Log;
import org.apache.commons.logging.LogFactory;

import com.spagettikod.t437.T437;
import com.xerox.amazonws.sdb.Domain;
import com.xerox.amazonws.sdb.Item;
import com.xerox.amazonws.sdb.ItemAttribute;
import com.xerox.amazonws.sdb.QueryResult;
import com.xerox.amazonws.sdb.SDBException;

public class SimpleDBTableModel extends AbstractTableModel
{
	private static final long serialVersionUID = -5552521277819622631L;

	private static final Log log = LogFactory.getLog(SimpleDBTableModel.class);

	private List<String> itemKeys = new LinkedList<String>();

	private LinkedList<String> columnNames = new LinkedList<String>();

	private LinkedList<Hashtable<String, String>> columnValues = new LinkedList<Hashtable<String, String>>();

	private String nextToken = null;

	private Domain domain;

	public SimpleDBTableModel(Domain domain)
	{
		this.domain = domain;

		columnNames.clear();
		columnValues.clear();
		itemKeys.clear();
	}

	public void queryData(String queryString, int rowsToFetch)
	{
		columnNames.clear();
		columnValues.clear();
		itemKeys.clear();
		fetchData(queryString, rowsToFetch, true);
	}

	public void fetchData(String queryString, int rowsToFetch, boolean forceFetch)
	{
		if (!isLastRowRead() || forceFetch)
		{
			if (log.isDebugEnabled())
			{
				log.debug("Fetching " + rowsToFetch + " rows");
			}
			try
			{
				QueryResult qr = domain.listItems(queryString, nextToken, rowsToFetch);
				nextToken = qr.getNextToken();
				List<Item> itemList = qr.getItemList();

				List<String> keys = new LinkedList<String>();

				for (Item item : itemList)
				{
					keys.add(item.getIdentifier());
				}

				Map<String, List<ItemAttribute>> items = domain.getItemsAttributes(keys);

				for (String key : items.keySet())
				{
					List<ItemAttribute> attributes = items.get(key);
					Hashtable<String, String> cols = new Hashtable<String, String>();
					for (ItemAttribute attr : attributes)
					{
						String name = attr.getName();
						if (!columnNames.contains(name))
						{
							columnNames.add(name);
						}
						String currValue = cols.get(name);
						if (currValue == null)
						{
							cols.put(name, attr.getValue());
						}
						else
						{
							cols.put(name, currValue + ", " + attr.getValue());
						}
					}
					columnValues.add(cols);
					itemKeys.add(key);
				}

				super.fireTableStructureChanged();
			}
			catch (SDBException e)
			{
				log.error("Error while fetching data", e);
				// TODO Should really be moved closer to the UI classes, throw
				// exception instead
				T437.displayErrorMessage("Error while fetching data", e.getLocalizedMessage());
			}
		}
		else
		{
			log.debug("All rows already fetched");
		}
	}

	@Override
	public String getColumnName(int column)
	{
		if (T437.getConfigurator().isSDBRowNumberShown())
		{
			if (column == 0)
			{
				return "#";
			}
			else if (column == 1)
			{
				return "Item Name";
			}
			return columnNames.get(column - 2);
		}
		else
		{
			if (column == 0)
			{
				return "Item Name";
			}
			return columnNames.get(column - 1);
		}
	}

	public int getColumnCount()
	{
		if (T437.getConfigurator().isSDBRowNumberShown())
		{
			return columnNames.size() + 2;
		}
		else
		{
			return columnNames.size() + 1;
		}
	}

	public int getRowCount()
	{
		if (columnValues == null)
			return 0;
		else
			return columnValues.size();
	}

	public Object getValueAt(int rowIndex, int columnIndex)
	{
		if (columnValues == null)
		{
			return "";
		}
		else if (columnIndex == 0 && T437.getConfigurator().isSDBRowNumberShown())
		{
			return new Integer(rowIndex + 1);
		}
		else if ((columnIndex == 1 && T437.getConfigurator().isSDBRowNumberShown())
				|| (!T437.getConfigurator().isSDBRowNumberShown() && columnIndex == 0))
		{
			return itemKeys.get(rowIndex);
		}
		else
		{
			Hashtable<String, String> row = columnValues.get(rowIndex);
			return row.get(getColumnName(columnIndex));
		}
	}

	public boolean isLastRowRead()
	{
		if (log.isDebugEnabled())
		{
			log.debug("Is last row read? " + (nextToken == null));
		}
		return (nextToken == null);
	}

	public Class<?> getColumnClass(int columnIndex)
	{
		if (columnIndex == 0 && T437.getConfigurator().isSDBRowNumberShown())
		{
			return Integer.class;
		}
		else
		{
			return String.class;
		}
	}
}